from sqlalchemy import create_engine, Column, Integer, String, Float
from sqlalchemy.ext.declarative import declarative_base

#定义基类
Base = declarative_base()

class sys_user(Base):
    __tablename__ = "sys_user"
    user_id = Column(Integer, primary_key=True)
    dept_ids = Column(String(500))
    dept_names = Column(String(500))
    user_name = Column(String(30))
    nick_name = Column(String(30))
    email = Column(String(50))
    phonenumber = Column(String(11))
    base_manager_ids = Column(String(500))
    base_manager_names = Column(String(500))